// Loads multiple Person objects.
private static Persons Load(DbDataAccess dbDataAccess
  , DbColumns dataDefinition)
{
  Person retValue = null;

  // Create the list of included columns.
  // This list should include the database assigned columns.
  List<string> columnNames = new List<string>();
  foreach (DbColumn column in dataDefinition)
  {
    columnNames.Add(column.ColumnName);
  }

  // Create a Data Columns object with the included data definitions
  // and values from the data record.
  var dataColumns = DbCommon.QueryColumns(columnNames, dataDefinition);

  // Create Key Columns.
  var keyColumns = new DbColumns()
  {
    { "Name", (object)"TestName" }
  };
  dataDefinition.LJCSetExcludeKeyValue("PrincipleFlag");
 
  var queryKeyColumns = DbCommon.QueryKeys(keyColumns, dataDefinition);

  // Create a query with the retrieve columns.
  // The retrieved columns should include the DB assigned columns.
  DbRequest dbRequest = new DbRequest()
  {
    Columns = dataColumns
    //KeyColumns = queryKeyColumns
    QueryType = QueryType.Load.ToString(),
    TableName = "PersonTest",
  };
  DbResult dbResult = dbDataAccess.Execute(dbRequest);

  if (dbResult != null)
  {
    string sqlStatement = dbResult.ExecutedSql;
    if (dbResult.DbRecords != null && dbResult.DbRecords.Count > 0)
    {
      retValue = new Persons();
      foreach (DbValues dbValues in dbResult.DbRecords)
      {
        Person person = new Person();
        DbCommon.SetObjectValues(dbValues, retValue);
        retValue.Add(person);
      }
    }
  }
  return retValue;
}